using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace LHS.Core.TableInfo
{
    public class InfoUserUpdatedInvoices
    {
        public const string USNISN = "usnISN";
        public const string USRISN = "usrISN";
        public const string INVISN = "invISN";
        public const string CLRISN = "clrISN";
        public const string USNDATE = "usnDate";
        public const string USNREASON = "usnReason";
        public const string USNSTATUS = "usnStatus"; //1: nhap hoa don; 0: cap nhat hoa don; 2: xoa hoa don
        public const string USNMONEYBEFOREUPDATE = "usnMoneyBeforeUpdate";

        public const string TABLENAME = "UserUpdatedInvoices";

        public static DataTable GetStructure()
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(USNISN, typeof(int));
            dt.Columns.Add(USRISN, typeof(int));
            dt.Columns.Add(INVISN, typeof(int));
            dt.Columns.Add(CLRISN, typeof(int));
            dt.Columns.Add(USNDATE, typeof(DateTime));
            dt.Columns.Add(USNREASON, typeof(string));
            dt.Columns.Add(USNSTATUS, typeof(int)); 
            dt.Columns.Add(USNMONEYBEFOREUPDATE, typeof(decimal ));

            dt.TableName = TABLENAME;
            return dt;
        }

    }
}
